﻿CREATE TABLE [dbo].[EquityInstrument] (
    [Id]              INT           NOT NULL CONSTRAINT [FK_EquityInstrument] FOREIGN KEY ([Id]) REFERENCES [dbo].[Instrument] ([Id]),
    --[Version]         ROWVERSION    NOT NULL,
    --[ModifiedBy]      INT           NOT NULL,
    --[ModifiedDt]      DATETIME      NOT NULL,
    
	[Ticker]          VARCHAR (255) NOT NULL,
	[LotSize]		  INT NOT NULL CONSTRAINT [DF_EquityInstrument_LotSize] DEFAULT(1),
    [DefaultCurrency] CHAR (3)      NULL --CONSTRAINT [FK_EquityInstrumentCurrency] FOREIGN KEY ([DefaultCurrency]) REFERENCES [dbo].[CurrencyInstrument] ([Code])
    CONSTRAINT [PK_EquityInstrument] PRIMARY KEY CLUSTERED ([Id] ASC)  
    
);

